Entity Relationships - Allowances and Invoicing (ALLOWANCEITEMS)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
ALLOWANCEITEMS	Allowance Items	ITEMID				Stores details of items for which allowances can be claimed.
TRALLOWANCEITEMS	Trainee Allowances	TRAINEEID, TRALLOWID	ALLOWANCEITEMS	One to many	ITEMID	Lists the allowance items that each trainee is allocated.
INVOICEDETAILS	Invoice Details	INVOICEID, LINEID	ALLOWANCEITEMS	One to many	ITEMID to ALLOWANCEITEMID	Stores details of individual invoice lines.
INVOICE	Invoice Summary	INVOICEID	INVOICEDETAILS	Many to one	INVOICEID, TRAINEEID	Stores a summary of each invoice.
ALLOWANCEBATCH	Allowances Batch Run	BATCH, CENTREID	INVOICE	One to one	BATCH	Stores details of batch runs for allowances.
PAYSLIPDETAILS	Payslip Details	PAYSLIPID, LINEID	INVOICEDETAILS	One to one	ALLOWANCEITEMID, LINEID, TRAINEEID	Stores details of individual payslip lines.
PAYSLIP	Payslip Summary	PAYSLIPID	PAYSLIPDETAILS	Many to one	PAYSLIPID, TRAINEEID	Stores a summary of each payslip.